This article covers how to use Power Automate to automate the extraction of email attachments for a given email account and uniquely save the files in a SharePoint folder.
In this tip, we'll cover a solution that retrieves a file from Azure Blob storage into the memory of an Azure Function.
This resource includes several links to related topics to help you prepare for and pass exam PL-900 Microsoft Power Platform Fundamentals.
This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema. 
In this article, we will go through the steps to create and format a bullet chart in Power BI.
Learn about the new bitwise operators in SQL Server 2022 along with a practical example of how to use these new operators.
Serverless computing is pushing C# to evolve to the next level. This is exciting because you pay-per-use and only incur charges when the code is running. This means that .NET 6 must spin up fast, do its job, then die quickly. This mantra of birth and rebirth pushes developers and the underlying tech to think …
The post AWS Lambdas with C# appeared first on Simple Talk.
This article provides a clear overview of the key cloud roles and responsibilities involved in cloud platform transformation and administration. These roles include leadership, development, and support personas at both cloud and traditional levels that all play a role in advancing an organization's evolutionary and revolutionary goals.
In this article, we look at the steps to add another disk to an existing Windows Failover Cluster used for SQL Server and also how to move an existing database to this new disk.
The use of SQL Server in the cloud continues to grow, but there is still the need to manage on-premises installations. Learn about one tool that can help you manage all of your SQL Server installations whether they are on-premises or in the cloud to help you be more productive and save money at the same time.
In this article, we look at how to migrate data from MySQL to SQL Server and how to keep the data between the two databases synchronized.
In this tip, we look at filtered indexes and how to create them in SQL Server as well as how to get a filtered index to work when pulling data back from more than one table.
Learn how to setup, configure and ingest data from Google Drive using Azure Data Factory in this step-by-step article.
This article looks at several ways to handle the SSIS error: cannot convert between Unicode and non-Unicode string data types.
This article covers how to download data into a SQL Server database to do a comparison of whether leveraged versus unleveraged ETF are a better long-term investment.
This simple reference guide shows you various ways to query SQL Server data based on various date and time clauses.
This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.
In this article, we cover how to encrypt a SQL Server stored procedure and how SQL Server hides the source code for these objects once encrypted.
Learn how to load Twitter data to a SQL Server database using Python code and the Twitter API to execute queries and analysis in SQL Server.
In this article, we look at different ways to transfer data from SQL Server to MongoDB when using SQL Server Integration Services.
Learn how to connect Azure Data Lake Gen2 storage to Power BI to develop reports and charts using files stored in Azure.
In this article, we look at how to resolve the issue of an Always On Availability Group database not synchronizing and how to fix this issue.
Learn how to use SQL Server or Oracle as the backend database for a simple .Net Core Web Application.
This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.
Learn how to build SQL Server indexes using key and non-key columns to create covering indexes that can help improve SQL Server performance.
Learn how to download, install and configure SQL Server 2019 Express Edition in this step-by-step article.
In this article, we look at how to setup and configure Contained Availability Groups in SQL Server 2022 and some of the new options this feature allows.: Redgate Hub Product articles University Events Forums Community Simple Talk Home Cloud DevOps Sysadmin Development Databases Opinion Books Blogs Log in Sign up Grant Fritchey 09 January 2023 0 41 views 0 Home Databases PostgreSQL Index Types in PostgreSQL : Learning PostgreSQL with Grant Grant Fritchey 09 January 2023 41 views 0 0 Index Types in PostgreSQL : Learning PostgreSQL with Grant As with any other relational data management system RDBMS PostgreSQL uses indexes as a mechanism to improve data access . PostgreSQL has a number of different index types , supporting different behaviors and different types of data . In addition , again , similar to other RDBMS , there are properties and behaviors associated with these . indexes In this article Iâ m going to go over the different types
This article intends to cover a few tips for creating a technology roadmap for your organization by identifying requirements, priorities, stakeholders, and plans.
Learn about SQL Server schemas and how to use them to organize database objects, assign permissions, and easier management of database objects.
Learn how to unpivot repeated data columns in a dataset to normalize the data so it can be used in Power BI reports and charts.As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulation language (DML) statement. You can join multiple tables in a single query or add subqueries that pull data in from other tables. You can also access views and temporary tables from within a statement, often …
The post Introducing the MySQL common table expression appeared first on Simple Talk.
Learn how to install and use Azure Data Studio in this introduction to getting started with Azure Data Studio.
In this article, we look at how to add a Report Server project to an existing Visual Studio Solution for a database and website along with how to develop reports.